AdProgramCourse 
Logical Entity Name  AdProgramCourse 
Default Table Name  AdProgramCourse 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

AdProgramCourse Columns 
ColumnName  Domain  Datatype  NULL  Definition 
AdProgramVersionID(FK)    int  YES 
 
AdProgramCourseCategoryID    int  NO 
 
AdCourseID(FK)    int  NO 
 
AllowSubstitute    bit  NO 
 
ElectiveCredits    numeric(9, 2)  YES 
 
ElectiveHours    numeric(9, 2)  YES 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
UserID    int  NO 
 
ts    timestamp  NO 
 
AdProgramCourseID(PK)    int  NO 
 
AdProgramElectivePoolID    int  YES 
 
ElectivePoolDescrip    varchar(60)  YES 
 
MaxNumOfRepeat    int  NO 
 
RequiresAdvisement    bit  NO 
 
AdConcentrationID(FK)    int  YES 
 
MinGPA    numeric(5, 2)  YES 
 
Credits    money  YES 
 
Hours    money  YES 
 
IsExcludeDrops    bit  NO 
 
TmpAdProgramCourseID    int  YES 
 
SkillsMinGPA    numeric(5, 2)  YES 
 
DisplayOrder    int  YES 
 
CourseAddedFrom    char(2)  YES 
 
Comment    nvarchar(1000)  YES 
 

AdProgramCourse Primary and Unique Keys 
Key Name  Key Type  Keys 
AdProgramCourse_AdProgramCourseID_U_C_IDX  PrimaryKey  AdProgramCourseID 

AdProgramCourse Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdConcentration  Non-Identifying  Zero or One to Zero or More  FK_AdProgramCourse.AdConcentrationID_AdConcentration.AdConcentrationID      AdConcentrationID  NO  YES 
AdCourse  Non-Identifying  One To Zero or More  FK_AdProgramCourse_AdCourseID_AdCourse_AdCourseID      AdCourseID  NO  YES 
AdProgramVersion  Non-Identifying  Zero or One to Zero or More  FK_AdProgramCourse_AdProgramVersionID_AdProgramVersion_AdProgramVersionID      AdProgramVersionID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
AdConcentrationElectivePoolRequirementRule  Non-Identifying  One To Zero or More  FK_AdConcentrationElectivePoolRequirementRule_AdProgramCourseID_AdProgramCourse_AdProgramCourseID        NO  YES 
AdConcentrationSubstitutePoolRequirementRule  Non-Identifying  One To Zero or More  FK_AdConcentrationSubstitutePoolRequirementRule_AdProgramCourseID_AdProgramCourse_AdProgramCourseID        NO  YES 
AdEnrollDegreeAuditCourse  Non-Identifying  One To Zero or More  FK_AdEnrollDegreeAuditCourse_AdProgramCourseID_AdProgramCourse_AdProgramCourseID        NO  YES 
adProgramCourseAttribute  Identifying  One To Zero or More  FK_adProgramCourseAttribute_AdProgramCourseID_AdCourse_AdProgramCourseID        NO  YES 
AdProgramElectivePoolRequirementRule  Non-Identifying  One To Zero or More  FK_AdProgramElectivePoolRequirementRule_AdProgramCourseID_AdProgramCourse_AdProgramCourseID        NO  YES 
AdProgramSubstitutePoolRequirementRule  Non-Identifying  One To Zero or More  FK_AdProgramSubstitutePoolRequirementRule_AdProgramCourseID_AdProgramCourse_AdProgramCourseID        NO  YES 

AdProgramCourse Check Constraints 
Check Constraint Name  CheckConstraint 
Chk_AdProgramCourse_AdProgramVersionID_AdConcentrationID  ([AdProgramVersionID] is null and [AdConcentrationID] is not null or [AdProgramVersionID] is not null and [AdConcentrationID] is null) 

AdProgramCourse Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

AdProgramCourse Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.RequiredCourse 
NO       
Physical (Microsoft SQL Server)
dbo.AdProgramCourse 
NO       

AdProgramCourse Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  DegreePathway 
Logical  Program/ProgramVersion 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 

AdProgramCourse Data Movement Rules 
Name  Type  Rule Text/Value